USE [iicdb]
GO

/****** Object:  View [dbo].[vReportExamSchedule]    Script Date: 12/09/2011 21:26:57 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vReportPresentationSheet]'))
DROP VIEW [dbo].[vReportPresentationSheet]
GO

USE [iicdb]
GO

/****** Object:  View [dbo].[vReportPresentationSheet]    Script Date: 12/09/2011 21:26:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[vReportPresentationSheet] AS

SELECT	RTRIM(Student.FirstName) + ' ' + RTRIM(Student.LastName) AS 'FullName', Student.IdNumber,
		ClassMember.CandidateCode, ClassMember.ClassId,
		Lesson.LessonName
FROM	Student INNER JOIN
		ClassMember ON Student.StudentId = ClassMember.StudentId INNER JOIN
			Class ON ClassMember.ClassId = Class.ClassId INNER JOIN
				Lesson ON Class.LessonId = Lesson.LessonId
                      
GO
